package vipcard.meichehui.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;
import vipcard.meichehui.domain.CarMoney;
import vipcard.meichehui.domain.Vip;

//核销
@Mapper

@Component
public interface CardMoneyMapper extends BaseMapper<CarMoney> {


    @Update("UPDATE card_roll SET status_date = #{status_date} WHERE uid=#{uid} ")
   Integer  heixiao(@Param("status_date") String status_date,@Param("uid") String uid);


    @Select("select id from sys_vip where nickname=#{nickname}")
    Integer findbyid(@Param("nickname") String nickname);

    @Select("select status_date from card_roll where uid=#{uid}")
    String findMoney(@Param("uid") String uid);

}
